# coding gbk
import sqlite3

conn = sqlite3.connect('identifier.sqlite')
print("Opend database successfully")
c = conn.cursor()
v_sql = "insert into user_test values(2,'xiaozhu')"
c.execute(v_sql)
conn.commit()

cursor = c.execute("select * from user_test")


for row in cursor:
    print("ID = ",row[0], ' user = ', row[1])

conn.close()
